Use Indexes to optimise my query OR Mysql

join shbcf.ru